Cost Data CSV Structure

This topic includes the cost data .csv file structure, an example, and the field list with data types.

File Structure

When you import cost data in Acumen using a .csv file, the data must be in a specific order, with specific data types. The screenshots below show the .csv file structure.

Example

Below is an example of a .cvs file.

Field List

The tables below describe the field names and type of data that you can use in the .csv file.

CPRs

Field	Data Type
ReportStartDate	DateTime
ReportEndDate	DateTime
SubmittalDate	DateTime
CBB	Number
TAB	Number
PMB	Number
ManagementReserve	Number
DistributedBudget	Number
UndistributedBudget	Number

Control Accounts

Field	Data Type
ID	String
WbsID	String
ObsID	String
ActualFinishDate	Number
ActualStartDate	Number
AcwpCum	Number
AcwpCumHours	Number
AcwpCur	Number
AcwpCurHours	Number
Bac	Number
BacHours	Number
BaselineFinishDate	DateTime
BaselineStartDate	DateTime
BcwpCum	Number
BcwpCumHours	Number
BcwpCur	Number
BcwpCurHours	Number
BcwsCum	Number
BcwsCumHours	Number
BcwsCur	Number
BcwsCurHours	Number
PercentageComplete	Number
Description	String
Eac	Number
EacHours	Number
EacNonLabor	Number
EarlyFinishDate	DateTime
EarlyStartDate	DateTime
ForecastFinishDate	DateTime
ForecastStartDate	DateTime
LateFinishDate	DateTime
LateStartDate	DateTime
Manager	String
PendingFinishDate	DateTime
PendingStartDate	DateTime
PerformanceMethod	Use one of the following values: None PercentComplete PercentCompleteManualEntry HundredZero ZeroHundred FiftyFifty Apportioned AssignmentPercentageComplete CalculatedApportioned EarnedAsSpent EarningRules LevelOfEffort Milestone PlanningPackage UnitsComplete UserDefined
ReprogrammingBudget	Number
ReprogrammingCostVariance	Number
ReprogrammingScheduleVariance	Number
StartPercentage	Number
Status	Use one of the following values: Unopened Open Closed
UnitsComplete	Number
UnitsToDo	Number
CPICur	Number
CPICum	Number
SPICur	Number
SPICum	Number
TCPIBacCur	Number
TCPIBacCum	Number
TCPIEacCur	Number
TCPIEacCum	Number
CPICurHours	Number
CPICumHours	Number
SPICurHours	Number
SPICumHours	Number
TCPIBacCurHours	Number
TCPIBacCumHours	Number
TCPIEacCurHours	Number
TCPIEacCumHours	Number

Work Packages

Field	Data Type
WorkPackageID	String
ControlAccountID	String
ActualFinishDate	Number
ActualStartDate	Number
AcwpCum	Number
AcwpCumHours	Number
AcwpCur	Number
AcwpCurHours	Number
Bac	Number
BacHours	Number
BaselineFinishDate	DateTime
BaselineStartDate	DateTime
BcwpCum	Number
BcwpCumHours	Number
BcwpCur	Number
BcwpCurHours	Number
BcwsCum	Number
BcwsCumHours	Number
BcwsCur	Number
BcwsCurHours	Number
PercentageComplete	Number
Description	String
Eac	Number
EacHours	Number
EacNonLabor	Number
EarlyFinishDate	DateTime
EarlyStartDate	DateTime
ForecastFinishDate	DateTime
ForecastStartDate	DateTime
LateFinishDate	DateTime
LateStartDate	DateTime
Manager	String
PendingFinishDate	DateTime
PendingStartDate	DateTime
PerformanceMethod	Use one of the following values: None PercentComplete PercentCompleteManualEntry HundredZero ZeroHundred FiftyFifty Apportioned AssignmentPercentageComplete CalculatedApportioned EarnedAsSpent EarningRules LevelOfEffort Milestone PlanningPackage UnitsComplete UserDefined
ReprogrammingBudget	Number
ReprogrammingCostVariance	Number
ReprogrammingScheduleVariance	Number
StartPercentage	Number
Status	Use one of the following values: Unopened Open Closed
UnitsComplete	Number
UnitsToDo	Number
CPICur	Number
CPICum	Number
SPICur	Number
SPICum	Number
TCPIBacCur	Number
TCPIBacCum	Number
TCPIEacCur	Number
TCPIEacCum	Number
CPICurHours	Number
CPICumHours	Number
SPICurHours	Number
SPICumHours	Number
TCPIBacCurHours	Number
TCPIBacCumHours	Number
TCPIEacCurHours	Number
TCPIEacCumHours	Number

Milestones

Field	DataType
Name	String
Description	String
ControlAccount	String
WorkPackage	String
ActualDate	DateTime
BaselineDate	DateTime
ScheduledDate	DateTime
PercentComplete	Number
Status	String
Weight	Number

Summary Totals

Field	Data Type
ControlAccount	String
WorkPackage	String
Resource	Use one of the following values: - for None L for Labor M for Material O for Other Direct Costs S for Subcontractor
UnitID	Use one of the following values: 1 for Dollar 2 for Hours
AcwpCum	Number
AcwpCur	Number
BcwpCum	Number
BcwpCur	Number
BcwsCum	Number
BcwsCur	Number
Bac	Number
Etc	Number
Eac	Number
CPICur	Number
CPICum	Number
SPICur	Number
SPICum	Number
TCPIBacCur	Number
TCPIBacCum	Number
TCPIEacCur	Number
TCPIEacCum	Number